﻿CREATE TABLE [dbo].[tblPackage] (
    [PackageID]        INT           IDENTITY (1, 1) NOT NULL,
    [ShippedDate]      SMALLDATETIME NULL,
    [CreateDate]       SMALLDATETIME NOT NULL,
    [TrackingNumber]   NVARCHAR (30) NULL,
    [BoxID]            NVARCHAR (15) NULL,
    [ConfirmationDate] SMALLDATETIME NULL,
    [CarrierCode]      int      NULL,
    [EstDeliveryDate]  SMALLDATETIME NULL,
	[PersonID]		   int not null,
	[AddressID]		   int not null,
	[OwnerID]		int not null,
	PrintBatchID	int null,
	[Weight]	float null
);


GO

